Average Non Graded Days KPI Card 18

Step 1: Create Avg Non Graded Days KPI Card

- Choose KPI card Visual

- Indicator = Average Non Graded Days, Trend Axis = DateEntered / Year, Target goals = Avg Non Graded Days Goals

- Select Format under General X position = 230, Y position = 143, Width = 289, Height = 160




- Indicator = Text size = 45, font family = Constantia, Horizontal alignment = Center, Vertical alignment = top

- Trend Axis on

- Goals on = Font color = black, font family = Constantia, text size = 12

- Color coding = low is good




- Title on = Avg Non Graded Days, font color = black, background color = light blue, alignment = centered, text size = 12, font family = Constantia

- Border = light gray

- Shadow on




Step 2: Create KPI Background

- Choose stacked area chart visual

- Axis = Rolling Weeks, Values = Average of Non Graded Days

- Select Format under General X position = 232, Y position = 172, Width = 292, Height = 137

- Turn off X Axis and X Axis title

- Turn off Y Axis and Y Axis title

- Title is off

- Background = Transparency should be 100%



How to create KPI card ?

https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates